﻿CREATE TABLE [dbo].[CRMListPatients] (
    [CRMListPatientID]   BIGINT          IDENTITY (1, 1) NOT NULL,
    [patientID]          BIGINT          NOT NULL,
    [crmListID]          INT             NOT NULL,
    [infoUpdated]        BIT             NOT NULL,
    [redCardDateUpdated] BIT             NOT NULL,
    [userNotes]          NVARCHAR (3000) NULL,
    [closed]             BIT             NOT NULL,
    [closedDate]         DATETIME        NULL,
    [openDate]           DATETIME        NOT NULL,
    [callbackDateTime]   DATETIME        NULL,
    [callbackNumber]     NVARCHAR (50)   NULL,
    [locked]             BIT             NOT NULL
);

